2012-01-22 - 3674 - Service Request - Report for all Invoice for EMEA 2011 #FICOSupport #EMEA

3674 - Report for all Invoice for EMEA 2011

Summary Description

---

Report Request for all the closed and open Invoices for the company code 0030 for year 2011.

Admin Info

---

Purpose	Report for all Invoice for EMEA 2011
Requested by	Jeff Mau
Issue Date	12-21-2012
Resolved by	Sai Valisetti
Resolved Date	12-21-2012
Document Status	Complete

Detailed Description

(Include Screen Shots if required )

---

Report Request for all the closed and open FI Invoices for the company code 0030 for year 2011.

Analysis and Recommendations

(Include Screen Shots if required)

---

Extracted the report for closed and open Invoices for company code 0030 using the tables BSID, BSAD tables.
Customer FI Invoices for year 2011 have 315 Closed Invoices (from BSID table)+13 Open Invoices(from BSAD Table) =328(Total), 355(Total Invoices List from the table BSIS)-328(Total)=27(Unknown.. could be parked, held or canceled)

13 open Invoices	22,508.27GPB
315 Closed Invoices	361,044.35 GBP
355 All Invoices		383,552.62	GBP
difference	0

Resolution

---

Release Information

---

Provide link here to Release Notes